Skip to main content

Datasource

The datasource is used to set the database and to specify the MQTT user and password. Depending on how many connections your connector is designed for, up to 10 datasources can now be created. The following attributes can be configured in the datasource: datasource_oracle.png

Each datasource has its own name, which can be freely chosen.

  • Database url:​

The database url is used to connect the Oracle Connector to the database. The url can either be a IPv4 address or a DNS entry. Example: 10.198.15.110 / my.dns.entry
Currently, the Oracle Connector only supports Oracle databases.

  • Database name:​

The name of the database to which the Oracle Connector should connect. The database must already be created and online so that the Oracle connector can connect to it.

  • Database port:​

The port of the database.

  • Database username:​

The user to connect to the database.

  • Database password:​

The password to connect to the database.

The buffer option is used to select between two insert modes. If this option is activated, a defined number of inserts will be collected before they are written to the database. If this option is not activated, buffering only takes place in the event of a connection to the database being lost.

  • Buffer size:​

The buffer size is the number of inserts that are collected before they are transferred to the database. If the buffer option is not activated, the buffer size is ignored.

  • MQTT user:​

The MQTT user to connect to the databus.

The user must have "Publish and Subscribe" rights to the following topics:

Oracle Connector:

  • Metadata topic: “ie/m/j/simatic/v1/orac1/dp”

  • Status topic: “ie/s/j/simatic/v1/orac1/status”

  • Data topic: “ie/d/j/simatic/v1/orac1/#

  • MQTT password:​

The MQTT password to connect to the databus.

  • Quoted Identifier:​

This encloses table and column names in quotation marks in all sql statements.

  • Heartbeat Rate​

Specifies the interval in ms where the connector verifies the connection to the database.

  • Heartbeat startup delay​

Specifies the delay after connector start until it starts performing connection checks to the database.



The optional fields "databus_service_name", "databus_username" and "databus_password" have been added to the datasource. These are used to ensure proper MQTT configuration to browse tags in the common configurator.



  • Databus service name​

the databus host including the port

  • Databus username​

The databus username which will be used to browse the tags.

  • Databus password​

The databus password which will be used to browse the tags.